<?php

use think\facade\Db;
use think\migration\Seeder;

class CityTableSeeder extends Seeder
{
    /**
     * Run Method.
     *
     * Write your database seeder using this method.
     *
     * More information on writing seeders is available here:
     * http://docs.phinx.org/en/latest/seeding.html
     */
    public function run()
    {
        $tempSql = $this->getSql();
        Db::query($tempSql);
    }

    protected function getSql()
    {
        return "INSERT INTO `city` (`id`, `name`, `city_code`, `province_code`) VALUES(1, '市辖区', '110100', '110000'),(2, '市辖区', '120100', '120000'),(3, '石家庄市', '130100', '130000'),(4, '唐山市', '130200', '130000'),(5, '秦皇岛市', '130300', '130000'),(6, '邯郸市', '130400', '130000'),(7, '邢台市', '130500', '130000'),(8, '保定市', '130600', '130000'),(9, '张家口市', '130700', '130000'),(10, '承德市', '130800', '130000'),(11, '沧州市', '130900', '130000'),(12, '廊坊市', '131000', '130000'),(13, '衡水市', '131100', '130000'),(14, '太原市', '140100', '140000'),(15, '大同市', '140200', '140000'),(16, '阳泉市', '140300', '140000'),(17, '长治市', '140400', '140000'),(18, '晋城市', '140500', '140000'),(19, '朔州市', '140600', '140000'),(20, '晋中市', '140700', '140000'),(21, '运城市', '140800', '140000'),(22, '忻州市', '140900', '140000'),(23, '临汾市', '141000', '140000'),(24, '吕梁市', '141100', '140000'),(25, '呼和浩特市', '150100', '150000'),(26, '包头市', '150200', '150000'),(27, '乌海市', '150300', '150000'),(28, '赤峰市', '150400', '150000'),(29, '通辽市', '150500', '150000'),(30, '鄂尔多斯市', '150600', '150000'),(31, '呼伦贝尔市', '150700', '150000'),(32, '巴彦淖尔市', '150800', '150000'),(33, '乌兰察布市', '150900', '150000'),(34, '兴安盟', '152200', '150000'),(35, '锡林郭勒盟', '152500', '150000'),(36, '阿拉善盟', '152900', '150000'),(37, '沈阳市', '210100', '210000'),(38, '大连市', '210200', '210000'),(39, '鞍山市', '210300', '210000'),(40, '抚顺市', '210400', '210000'),(41, '本溪市', '210500', '210000'),(42, '丹东市', '210600', '210000'),(43, '锦州市', '210700', '210000'),(44, '营口市', '210800', '210000'),(45, '阜新市', '210900', '210000'),(46, '辽阳市', '211000', '210000'),(47, '盘锦市', '211100', '210000'),(48, '铁岭市', '211200', '210000'),(49, '朝阳市', '211300', '210000'),(50, '葫芦岛市', '211400', '210000'),(51, '长春市', '220100', '220000'),(52, '吉林市', '220200', '220000'),(53, '四平市', '220300', '220000'),(54, '辽源市', '220400', '220000'),(55, '通化市', '220500', '220000'),(56, '白山市', '220600', '220000'),(57, '松原市', '220700', '220000'),(58, '白城市', '220800', '220000'),(59, '延边朝鲜族自治州', '222400', '220000'),(60, '哈尔滨市', '230100', '230000'),(61, '齐齐哈尔市', '230200', '230000'),(62, '鸡西市', '230300', '230000'),(63, '鹤岗市', '230400', '230000'),(64, '双鸭山市', '230500', '230000'),(65, '大庆市', '230600', '230000'),(66, '伊春市', '230700', '230000'),(67, '佳木斯市', '230800', '230000'),(68, '七台河市', '230900', '230000'),(69, '牡丹江市', '231000', '230000'),(70, '黑河市', '231100', '230000'),(71, '绥化市', '231200', '230000'),(72, '大兴安岭地区', '232700', '230000'),(73, '市辖区', '310100', '310000'),(74, '南京市', '320100', '320000'),(75, '无锡市', '320200', '320000'),(76, '徐州市', '320300', '320000'),(77, '常州市', '320400', '320000'),(78, '苏州市', '320500', '320000'),(79, '南通市', '320600', '320000'),(80, '连云港市', '320700', '320000'),(81, '淮安市', '320800', '320000'),(82, '盐城市', '320900', '320000'),(83, '扬州市', '321000', '320000'),(84, '镇江市', '321100', '320000'),(85, '泰州市', '321200', '320000'),(86, '宿迁市', '321300', '320000'),(87, '杭州市', '330100', '330000'),(88, '宁波市', '330200', '330000'),(89, '温州市', '330300', '330000'),(90, '嘉兴市', '330400', '330000'),(91, '湖州市', '330500', '330000'),(92, '绍兴市', '330600', '330000'),(93, '金华市', '330700', '330000'),(94, '衢州市', '330800', '330000'),(95, '舟山市', '330900', '330000'),(96, '台州市', '331000', '330000'),(97, '丽水市', '331100', '330000'),(98, '合肥市', '340100', '340000'),(99, '芜湖市', '340200', '340000'),(100, '蚌埠市', '340300', '340000'),(101, '淮南市', '340400', '340000'),(102, '马鞍山市', '340500', '340000'),(103, '淮北市', '340600', '340000'),(104, '铜陵市', '340700', '340000'),(105, '安庆市', '340800', '340000'),(106, '黄山市', '341000', '340000'),(107, '滁州市', '341100', '340000'),(108, '阜阳市', '341200', '340000'),(109, '宿州市', '341300', '340000'),(110, '六安市', '341500', '340000'),(111, '亳州市', '341600', '340000'),(112, '池州市', '341700', '340000'),(113, '宣城市', '341800', '340000'),(114, '福州市', '350100', '350000'),(115, '厦门市', '350200', '350000'),(116, '莆田市', '350300', '350000'),(117, '三明市', '350400', '350000'),(118, '泉州市', '350500', '350000'),(119, '漳州市', '350600', '350000'),(120, '南平市', '350700', '350000'),(121, '龙岩市', '350800', '350000'),(122, '宁德市', '350900', '350000'),(123, '南昌市', '360100', '360000'),(124, '景德镇市', '360200', '360000'),(125, '萍乡市', '360300', '360000'),(126, '九江市', '360400', '360000'),(127, '新余市', '360500', '360000'),(128, '鹰潭市', '360600', '360000'),(129, '赣州市', '360700', '360000'),(130, '吉安市', '360800', '360000'),(131, '宜春市', '360900', '360000'),(132, '抚州市', '361000', '360000'),(133, '上饶市', '361100', '360000'),(134, '济南市', '370100', '370000'),(135, '青岛市', '370200', '370000'),(136, '淄博市', '370300', '370000'),(137, '枣庄市', '370400', '370000'),(138, '东营市', '370500', '370000'),(139, '烟台市', '370600', '370000'),(140, '潍坊市', '370700', '370000'),(141, '济宁市', '370800', '370000'),(142, '泰安市', '370900', '370000'),(143, '威海市', '371000', '370000'),(144, '日照市', '371100', '370000'),(145, '临沂市', '371300', '370000'),(146, '德州市', '371400', '370000'),(147, '聊城市', '371500', '370000'),(148, '滨州市', '371600', '370000'),(149, '菏泽市', '371700', '370000'),(150, '郑州市', '410100', '410000'),(151, '开封市', '410200', '410000'),(152, '洛阳市', '410300', '410000'),(153, '平顶山市', '410400', '410000'),(154, '安阳市', '410500', '410000'),(155, '鹤壁市', '410600', '410000'),(156, '新乡市', '410700', '410000'),(157, '焦作市', '410800', '410000'),(158, '濮阳市', '410900', '410000'),(159, '许昌市', '411000', '410000'),(160, '漯河市', '411100', '410000'),(161, '三门峡市', '411200', '410000'),(162, '南阳市', '411300', '410000'),(163, '商丘市', '411400', '410000'),(164, '信阳市', '411500', '410000'),(165, '周口市', '411600', '410000'),(166, '驻马店市', '411700', '410000'),(167, '省直辖县级行政区划', '419000', '410000'),(168, '武汉市', '420100', '420000'),(169, '黄石市', '420200', '420000'),(170, '十堰市', '420300', '420000'),(171, '宜昌市', '420500', '420000'),(172, '襄阳市', '420600', '420000'),(173, '鄂州市', '420700', '420000'),(174, '荆门市', '420800', '420000'),(175, '孝感市', '420900', '420000'),(176, '荆州市', '421000', '420000'),(177, '黄冈市', '421100', '420000'),(178, '咸宁市', '421200', '420000'),(179, '随州市', '421300', '420000'),(180, '恩施土家族苗族自治州', '422800', '420000'),(181, '省直辖县级行政区划', '429000', '420000'),(182, '长沙市', '430100', '430000'),(183, '株洲市', '430200', '430000'),(184, '湘潭市', '430300', '430000'),(185, '衡阳市', '430400', '430000'),(186, '邵阳市', '430500', '430000'),(187, '岳阳市', '430600', '430000'),(188, '常德市', '430700', '430000'),(189, '张家界市', '430800', '430000'),(190, '益阳市', '430900', '430000'),(191, '郴州市', '431000', '430000'),(192, '永州市', '431100', '430000'),(193, '怀化市', '431200', '430000'),(194, '娄底市', '431300', '430000'),(195, '湘西土家族苗族自治州', '433100', '430000'),(196, '广州市', '440100', '440000'),(197, '韶关市', '440200', '440000'),(198, '深圳市', '440300', '440000'),(199, '珠海市', '440400', '440000'),(200, '汕头市', '440500', '440000'),(201, '佛山市', '440600', '440000'),(202, '江门市', '440700', '440000'),(203, '湛江市', '440800', '440000'),(204, '茂名市', '440900', '440000'),(205, '肇庆市', '441200', '440000'),(206, '惠州市', '441300', '440000'),(207, '梅州市', '441400', '440000'),(208, '汕尾市', '441500', '440000'),(209, '河源市', '441600', '440000'),(210, '阳江市', '441700', '440000'),(211, '清远市', '441800', '440000'),(212, '东莞市', '441900', '440000'),(213, '中山市', '442000', '440000'),(214, '潮州市', '445100', '440000'),(215, '揭阳市', '445200', '440000'),(216, '云浮市', '445300', '440000'),(217, '南宁市', '450100', '450000'),(218, '柳州市', '450200', '450000'),(219, '桂林市', '450300', '450000'),(220, '梧州市', '450400', '450000'),(221, '北海市', '450500', '450000'),(222, '防城港市', '450600', '450000'),(223, '钦州市', '450700', '450000'),(224, '贵港市', '450800', '450000'),(225, '玉林市', '450900', '450000'),(226, '百色市', '451000', '450000'),(227, '贺州市', '451100', '450000'),(228, '河池市', '451200', '450000'),(229, '来宾市', '451300', '450000'),(230, '崇左市', '451400', '450000'),(231, '海口市', '460100', '460000'),(232, '三亚市', '460200', '460000'),(233, '三沙市', '460300', '460000'),(234, '儋州市', '460400', '460000'),(235, '省直辖县级行政区划', '469000', '460000'),(236, '市辖区', '500100', '500000'),(237, '县', '500200', '500000'),(238, '成都市', '510100', '510000'),(239, '自贡市', '510300', '510000'),(240, '攀枝花市', '510400', '510000'),(241, '泸州市', '510500', '510000'),(242, '德阳市', '510600', '510000'),(243, '绵阳市', '510700', '510000'),(244, '广元市', '510800', '510000'),(245, '遂宁市', '510900', '510000'),(246, '内江市', '511000', '510000'),(247, '乐山市', '511100', '510000'),(248, '南充市', '511300', '510000'),(249, '眉山市', '511400', '510000'),(250, '宜宾市', '511500', '510000'),(251, '广安市', '511600', '510000'),(252, '达州市', '511700', '510000'),(253, '雅安市', '511800', '510000'),(254, '巴中市', '511900', '510000'),(255, '资阳市', '512000', '510000'),(256, '阿坝藏族羌族自治州', '513200', '510000'),(257, '甘孜藏族自治州', '513300', '510000'),(258, '凉山彝族自治州', '513400', '510000'),(259, '贵阳市', '520100', '520000'),(260, '六盘水市', '520200', '520000'),(261, '遵义市', '520300', '520000'),(262, '安顺市', '520400', '520000'),(263, '毕节市', '520500', '520000'),(264, '铜仁市', '520600', '520000'),(265, '黔西南布依族苗族自治州', '522300', '520000'),(266, '黔东南苗族侗族自治州', '522600', '520000'),(267, '黔南布依族苗族自治州', '522700', '520000'),(268, '昆明市', '530100', '530000'),(269, '曲靖市', '530300', '530000'),(270, '玉溪市', '530400', '530000'),(271, '保山市', '530500', '530000'),(272, '昭通市', '530600', '530000'),(273, '丽江市', '530700', '530000'),(274, '普洱市', '530800', '530000'),(275, '临沧市', '530900', '530000'),(276, '楚雄彝族自治州', '532300', '530000'),(277, '红河哈尼族彝族自治州', '532500', '530000'),(278, '文山壮族苗族自治州', '532600', '530000'),(279, '西双版纳傣族自治州', '532800', '530000'),(280, '大理白族自治州', '532900', '530000'),(281, '德宏傣族景颇族自治州', '533100', '530000'),(282, '怒江傈僳族自治州', '533300', '530000'),(283, '迪庆藏族自治州', '533400', '530000'),(284, '拉萨市', '540100', '540000'),(285, '日喀则市', '540200', '540000'),(286, '昌都市', '540300', '540000'),(287, '林芝市', '540400', '540000'),(288, '山南市', '540500', '540000'),(289, '那曲市', '540600', '540000'),(290, '阿里地区', '542500', '540000'),(291, '西安市', '610100', '610000'),(292, '铜川市', '610200', '610000'),(293, '宝鸡市', '610300', '610000'),(294, '咸阳市', '610400', '610000'),(295, '渭南市', '610500', '610000'),(296, '延安市', '610600', '610000'),(297, '汉中市', '610700', '610000'),(298, '榆林市', '610800', '610000'),(299, '安康市', '610900', '610000'),(300, '商洛市', '611000', '610000'),(301, '兰州市', '620100', '620000'),(302, '嘉峪关市', '620200', '620000'),(303, '金昌市', '620300', '620000'),(304, '白银市', '620400', '620000'),(305, '天水市', '620500', '620000'),(306, '武威市', '620600', '620000'),(307, '张掖市', '620700', '620000'),(308, '平凉市', '620800', '620000'),(309, '酒泉市', '620900', '620000'),(310, '庆阳市', '621000', '620000'),(311, '定西市', '621100', '620000'),(312, '陇南市', '621200', '620000'),(313, '临夏回族自治州', '622900', '620000'),(314, '甘南藏族自治州', '623000', '620000'),(315, '西宁市', '630100', '630000'),(316, '海东市', '630200', '630000'),(317, '海北藏族自治州', '632200', '630000'),(318, '黄南藏族自治州', '632300', '630000'),(319, '海南藏族自治州', '632500', '630000'),(320, '果洛藏族自治州', '632600', '630000'),(321, '玉树藏族自治州', '632700', '630000'),(322, '海西蒙古族藏族自治州', '632800', '630000'),(323, '银川市', '640100', '640000'),(324, '石嘴山市', '640200', '640000'),(325, '吴忠市', '640300', '640000'),(326, '固原市', '640400', '640000'),(327, '中卫市', '640500', '640000'),(328, '乌鲁木齐市', '650100', '650000'),(329, '克拉玛依市', '650200', '650000'),(330, '吐鲁番市', '650400', '650000'),(331, '哈密市', '650500', '650000'),(332, '昌吉回族自治州', '652300', '650000'),(333, '博尔塔拉蒙古自治州', '652700', '650000'),(334, '巴音郭楞蒙古自治州', '652800', '650000'),(335, '阿克苏地区', '652900', '650000'),(336, '克孜勒苏柯尔克孜自治州', '653000', '650000'),(337, '喀什地区', '653100', '650000'),(338, '和田地区', '653200', '650000'),(339, '伊犁哈萨克自治州', '654000', '650000'),(340, '塔城地区', '654200', '650000'),(341, '阿勒泰地区', '654300', '650000'),(342, '自治区直辖县级行政区划', '659000', '650000')";
    }
}